package com.jintoufs.domain.tour;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class TourRouteExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TourRouteExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("id like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("id not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andRouteNameIsNull() {
            addCriterion("route_name is null");
            return (Criteria) this;
        }

        public Criteria andRouteNameIsNotNull() {
            addCriterion("route_name is not null");
            return (Criteria) this;
        }

        public Criteria andRouteNameEqualTo(String value) {
            addCriterion("route_name =", value, "routeName");
            return (Criteria) this;
        }

        public Criteria andRouteNameNotEqualTo(String value) {
            addCriterion("route_name <>", value, "routeName");
            return (Criteria) this;
        }

        public Criteria andRouteNameGreaterThan(String value) {
            addCriterion("route_name >", value, "routeName");
            return (Criteria) this;
        }

        public Criteria andRouteNameGreaterThanOrEqualTo(String value) {
            addCriterion("route_name >=", value, "routeName");
            return (Criteria) this;
        }

        public Criteria andRouteNameLessThan(String value) {
            addCriterion("route_name <", value, "routeName");
            return (Criteria) this;
        }

        public Criteria andRouteNameLessThanOrEqualTo(String value) {
            addCriterion("route_name <=", value, "routeName");
            return (Criteria) this;
        }

        public Criteria andRouteNameLike(String value) {
            addCriterion("route_name like", value, "routeName");
            return (Criteria) this;
        }

        public Criteria andRouteNameNotLike(String value) {
            addCriterion("route_name not like", value, "routeName");
            return (Criteria) this;
        }

        public Criteria andRouteNameIn(List<String> values) {
            addCriterion("route_name in", values, "routeName");
            return (Criteria) this;
        }

        public Criteria andRouteNameNotIn(List<String> values) {
            addCriterion("route_name not in", values, "routeName");
            return (Criteria) this;
        }

        public Criteria andRouteNameBetween(String value1, String value2) {
            addCriterion("route_name between", value1, value2, "routeName");
            return (Criteria) this;
        }

        public Criteria andRouteNameNotBetween(String value1, String value2) {
            addCriterion("route_name not between", value1, value2, "routeName");
            return (Criteria) this;
        }

        public Criteria andTypeIdIsNull() {
            addCriterion("type_id is null");
            return (Criteria) this;
        }

        public Criteria andTypeIdIsNotNull() {
            addCriterion("type_id is not null");
            return (Criteria) this;
        }

        public Criteria andTypeIdEqualTo(String value) {
            addCriterion("type_id =", value, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdNotEqualTo(String value) {
            addCriterion("type_id <>", value, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdGreaterThan(String value) {
            addCriterion("type_id >", value, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdGreaterThanOrEqualTo(String value) {
            addCriterion("type_id >=", value, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdLessThan(String value) {
            addCriterion("type_id <", value, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdLessThanOrEqualTo(String value) {
            addCriterion("type_id <=", value, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdLike(String value) {
            addCriterion("type_id like", value, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdNotLike(String value) {
            addCriterion("type_id not like", value, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdIn(List<String> values) {
            addCriterion("type_id in", values, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdNotIn(List<String> values) {
            addCriterion("type_id not in", values, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdBetween(String value1, String value2) {
            addCriterion("type_id between", value1, value2, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdNotBetween(String value1, String value2) {
            addCriterion("type_id not between", value1, value2, "typeId");
            return (Criteria) this;
        }

        public Criteria andPersonNumIsNull() {
            addCriterion("person_num is null");
            return (Criteria) this;
        }

        public Criteria andPersonNumIsNotNull() {
            addCriterion("person_num is not null");
            return (Criteria) this;
        }

        public Criteria andPersonNumEqualTo(Integer value) {
            addCriterion("person_num =", value, "personNum");
            return (Criteria) this;
        }

        public Criteria andPersonNumNotEqualTo(Integer value) {
            addCriterion("person_num <>", value, "personNum");
            return (Criteria) this;
        }

        public Criteria andPersonNumGreaterThan(Integer value) {
            addCriterion("person_num >", value, "personNum");
            return (Criteria) this;
        }

        public Criteria andPersonNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("person_num >=", value, "personNum");
            return (Criteria) this;
        }

        public Criteria andPersonNumLessThan(Integer value) {
            addCriterion("person_num <", value, "personNum");
            return (Criteria) this;
        }

        public Criteria andPersonNumLessThanOrEqualTo(Integer value) {
            addCriterion("person_num <=", value, "personNum");
            return (Criteria) this;
        }

        public Criteria andPersonNumIn(List<Integer> values) {
            addCriterion("person_num in", values, "personNum");
            return (Criteria) this;
        }

        public Criteria andPersonNumNotIn(List<Integer> values) {
            addCriterion("person_num not in", values, "personNum");
            return (Criteria) this;
        }

        public Criteria andPersonNumBetween(Integer value1, Integer value2) {
            addCriterion("person_num between", value1, value2, "personNum");
            return (Criteria) this;
        }

        public Criteria andPersonNumNotBetween(Integer value1, Integer value2) {
            addCriterion("person_num not between", value1, value2, "personNum");
            return (Criteria) this;
        }

        public Criteria andTourDayIsNull() {
            addCriterion("tour_day is null");
            return (Criteria) this;
        }

        public Criteria andTourDayIsNotNull() {
            addCriterion("tour_day is not null");
            return (Criteria) this;
        }

        public Criteria andTourDayEqualTo(Integer value) {
            addCriterion("tour_day =", value, "tourDay");
            return (Criteria) this;
        }

        public Criteria andTourDayNotEqualTo(Integer value) {
            addCriterion("tour_day <>", value, "tourDay");
            return (Criteria) this;
        }

        public Criteria andTourDayGreaterThan(Integer value) {
            addCriterion("tour_day >", value, "tourDay");
            return (Criteria) this;
        }

        public Criteria andTourDayGreaterThanOrEqualTo(Integer value) {
            addCriterion("tour_day >=", value, "tourDay");
            return (Criteria) this;
        }

        public Criteria andTourDayLessThan(Integer value) {
            addCriterion("tour_day <", value, "tourDay");
            return (Criteria) this;
        }

        public Criteria andTourDayLessThanOrEqualTo(Integer value) {
            addCriterion("tour_day <=", value, "tourDay");
            return (Criteria) this;
        }

        public Criteria andTourDayIn(List<Integer> values) {
            addCriterion("tour_day in", values, "tourDay");
            return (Criteria) this;
        }

        public Criteria andTourDayNotIn(List<Integer> values) {
            addCriterion("tour_day not in", values, "tourDay");
            return (Criteria) this;
        }

        public Criteria andTourDayBetween(Integer value1, Integer value2) {
            addCriterion("tour_day between", value1, value2, "tourDay");
            return (Criteria) this;
        }

        public Criteria andTourDayNotBetween(Integer value1, Integer value2) {
            addCriterion("tour_day not between", value1, value2, "tourDay");
            return (Criteria) this;
        }

        public Criteria andStartPlaceIsNull() {
            addCriterion("start_place is null");
            return (Criteria) this;
        }

        public Criteria andStartPlaceIsNotNull() {
            addCriterion("start_place is not null");
            return (Criteria) this;
        }

        public Criteria andStartPlaceEqualTo(String value) {
            addCriterion("start_place =", value, "startPlace");
            return (Criteria) this;
        }

        public Criteria andStartPlaceNotEqualTo(String value) {
            addCriterion("start_place <>", value, "startPlace");
            return (Criteria) this;
        }

        public Criteria andStartPlaceGreaterThan(String value) {
            addCriterion("start_place >", value, "startPlace");
            return (Criteria) this;
        }

        public Criteria andStartPlaceGreaterThanOrEqualTo(String value) {
            addCriterion("start_place >=", value, "startPlace");
            return (Criteria) this;
        }

        public Criteria andStartPlaceLessThan(String value) {
            addCriterion("start_place <", value, "startPlace");
            return (Criteria) this;
        }

        public Criteria andStartPlaceLessThanOrEqualTo(String value) {
            addCriterion("start_place <=", value, "startPlace");
            return (Criteria) this;
        }

        public Criteria andStartPlaceLike(String value) {
            addCriterion("start_place like", value, "startPlace");
            return (Criteria) this;
        }

        public Criteria andStartPlaceNotLike(String value) {
            addCriterion("start_place not like", value, "startPlace");
            return (Criteria) this;
        }

        public Criteria andStartPlaceIn(List<String> values) {
            addCriterion("start_place in", values, "startPlace");
            return (Criteria) this;
        }

        public Criteria andStartPlaceNotIn(List<String> values) {
            addCriterion("start_place not in", values, "startPlace");
            return (Criteria) this;
        }

        public Criteria andStartPlaceBetween(String value1, String value2) {
            addCriterion("start_place between", value1, value2, "startPlace");
            return (Criteria) this;
        }

        public Criteria andStartPlaceNotBetween(String value1, String value2) {
            addCriterion("start_place not between", value1, value2, "startPlace");
            return (Criteria) this;
        }

        public Criteria andBackPlaceIsNull() {
            addCriterion("back_place is null");
            return (Criteria) this;
        }

        public Criteria andBackPlaceIsNotNull() {
            addCriterion("back_place is not null");
            return (Criteria) this;
        }

        public Criteria andBackPlaceEqualTo(String value) {
            addCriterion("back_place =", value, "backPlace");
            return (Criteria) this;
        }

        public Criteria andBackPlaceNotEqualTo(String value) {
            addCriterion("back_place <>", value, "backPlace");
            return (Criteria) this;
        }

        public Criteria andBackPlaceGreaterThan(String value) {
            addCriterion("back_place >", value, "backPlace");
            return (Criteria) this;
        }

        public Criteria andBackPlaceGreaterThanOrEqualTo(String value) {
            addCriterion("back_place >=", value, "backPlace");
            return (Criteria) this;
        }

        public Criteria andBackPlaceLessThan(String value) {
            addCriterion("back_place <", value, "backPlace");
            return (Criteria) this;
        }

        public Criteria andBackPlaceLessThanOrEqualTo(String value) {
            addCriterion("back_place <=", value, "backPlace");
            return (Criteria) this;
        }

        public Criteria andBackPlaceLike(String value) {
            addCriterion("back_place like", value, "backPlace");
            return (Criteria) this;
        }

        public Criteria andBackPlaceNotLike(String value) {
            addCriterion("back_place not like", value, "backPlace");
            return (Criteria) this;
        }

        public Criteria andBackPlaceIn(List<String> values) {
            addCriterion("back_place in", values, "backPlace");
            return (Criteria) this;
        }

        public Criteria andBackPlaceNotIn(List<String> values) {
            addCriterion("back_place not in", values, "backPlace");
            return (Criteria) this;
        }

        public Criteria andBackPlaceBetween(String value1, String value2) {
            addCriterion("back_place between", value1, value2, "backPlace");
            return (Criteria) this;
        }

        public Criteria andBackPlaceNotBetween(String value1, String value2) {
            addCriterion("back_place not between", value1, value2, "backPlace");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andCreatTimeIsNull() {
            addCriterion("creat_time is null");
            return (Criteria) this;
        }

        public Criteria andCreatTimeIsNotNull() {
            addCriterion("creat_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreatTimeEqualTo(Date value) {
            addCriterion("creat_time =", value, "creatTime");
            return (Criteria) this;
        }

        public Criteria andCreatTimeNotEqualTo(Date value) {
            addCriterion("creat_time <>", value, "creatTime");
            return (Criteria) this;
        }

        public Criteria andCreatTimeGreaterThan(Date value) {
            addCriterion("creat_time >", value, "creatTime");
            return (Criteria) this;
        }

        public Criteria andCreatTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("creat_time >=", value, "creatTime");
            return (Criteria) this;
        }

        public Criteria andCreatTimeLessThan(Date value) {
            addCriterion("creat_time <", value, "creatTime");
            return (Criteria) this;
        }

        public Criteria andCreatTimeLessThanOrEqualTo(Date value) {
            addCriterion("creat_time <=", value, "creatTime");
            return (Criteria) this;
        }

        public Criteria andCreatTimeIn(List<Date> values) {
            addCriterion("creat_time in", values, "creatTime");
            return (Criteria) this;
        }

        public Criteria andCreatTimeNotIn(List<Date> values) {
            addCriterion("creat_time not in", values, "creatTime");
            return (Criteria) this;
        }

        public Criteria andCreatTimeBetween(Date value1, Date value2) {
            addCriterion("creat_time between", value1, value2, "creatTime");
            return (Criteria) this;
        }

        public Criteria andCreatTimeNotBetween(Date value1, Date value2) {
            addCriterion("creat_time not between", value1, value2, "creatTime");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("status like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("status not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andCreaterIdIsNull() {
            addCriterion("creater_id is null");
            return (Criteria) this;
        }

        public Criteria andCreaterIdIsNotNull() {
            addCriterion("creater_id is not null");
            return (Criteria) this;
        }

        public Criteria andCreaterIdEqualTo(String value) {
            addCriterion("creater_id =", value, "createrId");
            return (Criteria) this;
        }

        public Criteria andCreaterIdNotEqualTo(String value) {
            addCriterion("creater_id <>", value, "createrId");
            return (Criteria) this;
        }

        public Criteria andCreaterIdGreaterThan(String value) {
            addCriterion("creater_id >", value, "createrId");
            return (Criteria) this;
        }

        public Criteria andCreaterIdGreaterThanOrEqualTo(String value) {
            addCriterion("creater_id >=", value, "createrId");
            return (Criteria) this;
        }

        public Criteria andCreaterIdLessThan(String value) {
            addCriterion("creater_id <", value, "createrId");
            return (Criteria) this;
        }

        public Criteria andCreaterIdLessThanOrEqualTo(String value) {
            addCriterion("creater_id <=", value, "createrId");
            return (Criteria) this;
        }

        public Criteria andCreaterIdLike(String value) {
            addCriterion("creater_id like", value, "createrId");
            return (Criteria) this;
        }

        public Criteria andCreaterIdNotLike(String value) {
            addCriterion("creater_id not like", value, "createrId");
            return (Criteria) this;
        }

        public Criteria andCreaterIdIn(List<String> values) {
            addCriterion("creater_id in", values, "createrId");
            return (Criteria) this;
        }

        public Criteria andCreaterIdNotIn(List<String> values) {
            addCriterion("creater_id not in", values, "createrId");
            return (Criteria) this;
        }

        public Criteria andCreaterIdBetween(String value1, String value2) {
            addCriterion("creater_id between", value1, value2, "createrId");
            return (Criteria) this;
        }

        public Criteria andCreaterIdNotBetween(String value1, String value2) {
            addCriterion("creater_id not between", value1, value2, "createrId");
            return (Criteria) this;
        }

        public Criteria andIntroductionIsNull() {
            addCriterion("introduction is null");
            return (Criteria) this;
        }

        public Criteria andIntroductionIsNotNull() {
            addCriterion("introduction is not null");
            return (Criteria) this;
        }

        public Criteria andIntroductionEqualTo(String value) {
            addCriterion("introduction =", value, "introduction");
            return (Criteria) this;
        }

        public Criteria andIntroductionNotEqualTo(String value) {
            addCriterion("introduction <>", value, "introduction");
            return (Criteria) this;
        }

        public Criteria andIntroductionGreaterThan(String value) {
            addCriterion("introduction >", value, "introduction");
            return (Criteria) this;
        }

        public Criteria andIntroductionGreaterThanOrEqualTo(String value) {
            addCriterion("introduction >=", value, "introduction");
            return (Criteria) this;
        }

        public Criteria andIntroductionLessThan(String value) {
            addCriterion("introduction <", value, "introduction");
            return (Criteria) this;
        }

        public Criteria andIntroductionLessThanOrEqualTo(String value) {
            addCriterion("introduction <=", value, "introduction");
            return (Criteria) this;
        }

        public Criteria andIntroductionLike(String value) {
            addCriterion("introduction like", value, "introduction");
            return (Criteria) this;
        }

        public Criteria andIntroductionNotLike(String value) {
            addCriterion("introduction not like", value, "introduction");
            return (Criteria) this;
        }

        public Criteria andIntroductionIn(List<String> values) {
            addCriterion("introduction in", values, "introduction");
            return (Criteria) this;
        }

        public Criteria andIntroductionNotIn(List<String> values) {
            addCriterion("introduction not in", values, "introduction");
            return (Criteria) this;
        }

        public Criteria andIntroductionBetween(String value1, String value2) {
            addCriterion("introduction between", value1, value2, "introduction");
            return (Criteria) this;
        }

        public Criteria andIntroductionNotBetween(String value1, String value2) {
            addCriterion("introduction not between", value1, value2, "introduction");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNull() {
            addCriterion("end_time is null");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNotNull() {
            addCriterion("end_time is not null");
            return (Criteria) this;
        }

        public Criteria andEndTimeEqualTo(Date value) {
            addCriterion("end_time =", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotEqualTo(Date value) {
            addCriterion("end_time <>", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThan(Date value) {
            addCriterion("end_time >", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("end_time >=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThan(Date value) {
            addCriterion("end_time <", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThanOrEqualTo(Date value) {
            addCriterion("end_time <=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeIn(List<Date> values) {
            addCriterion("end_time in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotIn(List<Date> values) {
            addCriterion("end_time not in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeBetween(Date value1, Date value2) {
            addCriterion("end_time between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotBetween(Date value1, Date value2) {
            addCriterion("end_time not between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeIsNull() {
            addCriterion("start_time is null");
            return (Criteria) this;
        }

        public Criteria andStartTimeIsNotNull() {
            addCriterion("start_time is not null");
            return (Criteria) this;
        }

        public Criteria andStartTimeEqualTo(Date value) {
            addCriterion("start_time =", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotEqualTo(Date value) {
            addCriterion("start_time <>", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeGreaterThan(Date value) {
            addCriterion("start_time >", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("start_time >=", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeLessThan(Date value) {
            addCriterion("start_time <", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeLessThanOrEqualTo(Date value) {
            addCriterion("start_time <=", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeIn(List<Date> values) {
            addCriterion("start_time in", values, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotIn(List<Date> values) {
            addCriterion("start_time not in", values, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeBetween(Date value1, Date value2) {
            addCriterion("start_time between", value1, value2, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotBetween(Date value1, Date value2) {
            addCriterion("start_time not between", value1, value2, "startTime");
            return (Criteria) this;
        }

        public Criteria andLastmodifyTimeIsNull() {
            addCriterion("lastmodify_time is null");
            return (Criteria) this;
        }

        public Criteria andLastmodifyTimeIsNotNull() {
            addCriterion("lastmodify_time is not null");
            return (Criteria) this;
        }

        public Criteria andLastmodifyTimeEqualTo(Date value) {
            addCriterion("lastmodify_time =", value, "lastmodifyTime");
            return (Criteria) this;
        }

        public Criteria andLastmodifyTimeNotEqualTo(Date value) {
            addCriterion("lastmodify_time <>", value, "lastmodifyTime");
            return (Criteria) this;
        }

        public Criteria andLastmodifyTimeGreaterThan(Date value) {
            addCriterion("lastmodify_time >", value, "lastmodifyTime");
            return (Criteria) this;
        }

        public Criteria andLastmodifyTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("lastmodify_time >=", value, "lastmodifyTime");
            return (Criteria) this;
        }

        public Criteria andLastmodifyTimeLessThan(Date value) {
            addCriterion("lastmodify_time <", value, "lastmodifyTime");
            return (Criteria) this;
        }

        public Criteria andLastmodifyTimeLessThanOrEqualTo(Date value) {
            addCriterion("lastmodify_time <=", value, "lastmodifyTime");
            return (Criteria) this;
        }

        public Criteria andLastmodifyTimeIn(List<Date> values) {
            addCriterion("lastmodify_time in", values, "lastmodifyTime");
            return (Criteria) this;
        }

        public Criteria andLastmodifyTimeNotIn(List<Date> values) {
            addCriterion("lastmodify_time not in", values, "lastmodifyTime");
            return (Criteria) this;
        }

        public Criteria andLastmodifyTimeBetween(Date value1, Date value2) {
            addCriterion("lastmodify_time between", value1, value2, "lastmodifyTime");
            return (Criteria) this;
        }

        public Criteria andLastmodifyTimeNotBetween(Date value1, Date value2) {
            addCriterion("lastmodify_time not between", value1, value2, "lastmodifyTime");
            return (Criteria) this;
        }

        public Criteria andTotalFeeIsNull() {
            addCriterion("total_fee is null");
            return (Criteria) this;
        }

        public Criteria andTotalFeeIsNotNull() {
            addCriterion("total_fee is not null");
            return (Criteria) this;
        }

        public Criteria andTotalFeeEqualTo(BigDecimal value) {
            addCriterion("total_fee =", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeNotEqualTo(BigDecimal value) {
            addCriterion("total_fee <>", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeGreaterThan(BigDecimal value) {
            addCriterion("total_fee >", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("total_fee >=", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeLessThan(BigDecimal value) {
            addCriterion("total_fee <", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("total_fee <=", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeIn(List<BigDecimal> values) {
            addCriterion("total_fee in", values, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeNotIn(List<BigDecimal> values) {
            addCriterion("total_fee not in", values, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("total_fee between", value1, value2, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("total_fee not between", value1, value2, "totalFee");
            return (Criteria) this;
        }

        public Criteria andRecommendIsNull() {
            addCriterion("recommend is null");
            return (Criteria) this;
        }

        public Criteria andRecommendIsNotNull() {
            addCriterion("recommend is not null");
            return (Criteria) this;
        }

        public Criteria andRecommendEqualTo(String value) {
            addCriterion("recommend =", value, "recommend");
            return (Criteria) this;
        }

        public Criteria andRecommendNotEqualTo(String value) {
            addCriterion("recommend <>", value, "recommend");
            return (Criteria) this;
        }

        public Criteria andRecommendGreaterThan(String value) {
            addCriterion("recommend >", value, "recommend");
            return (Criteria) this;
        }

        public Criteria andRecommendGreaterThanOrEqualTo(String value) {
            addCriterion("recommend >=", value, "recommend");
            return (Criteria) this;
        }

        public Criteria andRecommendLessThan(String value) {
            addCriterion("recommend <", value, "recommend");
            return (Criteria) this;
        }

        public Criteria andRecommendLessThanOrEqualTo(String value) {
            addCriterion("recommend <=", value, "recommend");
            return (Criteria) this;
        }

        public Criteria andRecommendLike(String value) {
            addCriterion("recommend like", value, "recommend");
            return (Criteria) this;
        }

        public Criteria andRecommendNotLike(String value) {
            addCriterion("recommend not like", value, "recommend");
            return (Criteria) this;
        }

        public Criteria andRecommendIn(List<String> values) {
            addCriterion("recommend in", values, "recommend");
            return (Criteria) this;
        }

        public Criteria andRecommendNotIn(List<String> values) {
            addCriterion("recommend not in", values, "recommend");
            return (Criteria) this;
        }

        public Criteria andRecommendBetween(String value1, String value2) {
            addCriterion("recommend between", value1, value2, "recommend");
            return (Criteria) this;
        }

        public Criteria andRecommendNotBetween(String value1, String value2) {
            addCriterion("recommend not between", value1, value2, "recommend");
            return (Criteria) this;
        }

        public Criteria andLastModifyByIdIsNull() {
            addCriterion("last_modify_by_id is null");
            return (Criteria) this;
        }

        public Criteria andLastModifyByIdIsNotNull() {
            addCriterion("last_modify_by_id is not null");
            return (Criteria) this;
        }

        public Criteria andLastModifyByIdEqualTo(String value) {
            addCriterion("last_modify_by_id =", value, "lastModifyById");
            return (Criteria) this;
        }

        public Criteria andLastModifyByIdNotEqualTo(String value) {
            addCriterion("last_modify_by_id <>", value, "lastModifyById");
            return (Criteria) this;
        }

        public Criteria andLastModifyByIdGreaterThan(String value) {
            addCriterion("last_modify_by_id >", value, "lastModifyById");
            return (Criteria) this;
        }

        public Criteria andLastModifyByIdGreaterThanOrEqualTo(String value) {
            addCriterion("last_modify_by_id >=", value, "lastModifyById");
            return (Criteria) this;
        }

        public Criteria andLastModifyByIdLessThan(String value) {
            addCriterion("last_modify_by_id <", value, "lastModifyById");
            return (Criteria) this;
        }

        public Criteria andLastModifyByIdLessThanOrEqualTo(String value) {
            addCriterion("last_modify_by_id <=", value, "lastModifyById");
            return (Criteria) this;
        }

        public Criteria andLastModifyByIdLike(String value) {
            addCriterion("last_modify_by_id like", value, "lastModifyById");
            return (Criteria) this;
        }

        public Criteria andLastModifyByIdNotLike(String value) {
            addCriterion("last_modify_by_id not like", value, "lastModifyById");
            return (Criteria) this;
        }

        public Criteria andLastModifyByIdIn(List<String> values) {
            addCriterion("last_modify_by_id in", values, "lastModifyById");
            return (Criteria) this;
        }

        public Criteria andLastModifyByIdNotIn(List<String> values) {
            addCriterion("last_modify_by_id not in", values, "lastModifyById");
            return (Criteria) this;
        }

        public Criteria andLastModifyByIdBetween(String value1, String value2) {
            addCriterion("last_modify_by_id between", value1, value2, "lastModifyById");
            return (Criteria) this;
        }

        public Criteria andLastModifyByIdNotBetween(String value1, String value2) {
            addCriterion("last_modify_by_id not between", value1, value2, "lastModifyById");
            return (Criteria) this;
        }

        public Criteria andLastModifyByNameIsNull() {
            addCriterion("last_modify_by_name is null");
            return (Criteria) this;
        }

        public Criteria andLastModifyByNameIsNotNull() {
            addCriterion("last_modify_by_name is not null");
            return (Criteria) this;
        }

        public Criteria andLastModifyByNameEqualTo(String value) {
            addCriterion("last_modify_by_name =", value, "lastModifyByName");
            return (Criteria) this;
        }

        public Criteria andLastModifyByNameNotEqualTo(String value) {
            addCriterion("last_modify_by_name <>", value, "lastModifyByName");
            return (Criteria) this;
        }

        public Criteria andLastModifyByNameGreaterThan(String value) {
            addCriterion("last_modify_by_name >", value, "lastModifyByName");
            return (Criteria) this;
        }

        public Criteria andLastModifyByNameGreaterThanOrEqualTo(String value) {
            addCriterion("last_modify_by_name >=", value, "lastModifyByName");
            return (Criteria) this;
        }

        public Criteria andLastModifyByNameLessThan(String value) {
            addCriterion("last_modify_by_name <", value, "lastModifyByName");
            return (Criteria) this;
        }

        public Criteria andLastModifyByNameLessThanOrEqualTo(String value) {
            addCriterion("last_modify_by_name <=", value, "lastModifyByName");
            return (Criteria) this;
        }

        public Criteria andLastModifyByNameLike(String value) {
            addCriterion("last_modify_by_name like", value, "lastModifyByName");
            return (Criteria) this;
        }

        public Criteria andLastModifyByNameNotLike(String value) {
            addCriterion("last_modify_by_name not like", value, "lastModifyByName");
            return (Criteria) this;
        }

        public Criteria andLastModifyByNameIn(List<String> values) {
            addCriterion("last_modify_by_name in", values, "lastModifyByName");
            return (Criteria) this;
        }

        public Criteria andLastModifyByNameNotIn(List<String> values) {
            addCriterion("last_modify_by_name not in", values, "lastModifyByName");
            return (Criteria) this;
        }

        public Criteria andLastModifyByNameBetween(String value1, String value2) {
            addCriterion("last_modify_by_name between", value1, value2, "lastModifyByName");
            return (Criteria) this;
        }

        public Criteria andLastModifyByNameNotBetween(String value1, String value2) {
            addCriterion("last_modify_by_name not between", value1, value2, "lastModifyByName");
            return (Criteria) this;
        }

        public Criteria andTravelAgencyIdIsNull() {
            addCriterion("travel_agency_id is null");
            return (Criteria) this;
        }

        public Criteria andTravelAgencyIdIsNotNull() {
            addCriterion("travel_agency_id is not null");
            return (Criteria) this;
        }

        public Criteria andTravelAgencyIdEqualTo(String value) {
            addCriterion("travel_agency_id =", value, "travelAgencyId");
            return (Criteria) this;
        }

        public Criteria andTravelAgencyIdNotEqualTo(String value) {
            addCriterion("travel_agency_id <>", value, "travelAgencyId");
            return (Criteria) this;
        }

        public Criteria andTravelAgencyIdGreaterThan(String value) {
            addCriterion("travel_agency_id >", value, "travelAgencyId");
            return (Criteria) this;
        }

        public Criteria andTravelAgencyIdGreaterThanOrEqualTo(String value) {
            addCriterion("travel_agency_id >=", value, "travelAgencyId");
            return (Criteria) this;
        }

        public Criteria andTravelAgencyIdLessThan(String value) {
            addCriterion("travel_agency_id <", value, "travelAgencyId");
            return (Criteria) this;
        }

        public Criteria andTravelAgencyIdLessThanOrEqualTo(String value) {
            addCriterion("travel_agency_id <=", value, "travelAgencyId");
            return (Criteria) this;
        }

        public Criteria andTravelAgencyIdLike(String value) {
            addCriterion("travel_agency_id like", value, "travelAgencyId");
            return (Criteria) this;
        }

        public Criteria andTravelAgencyIdNotLike(String value) {
            addCriterion("travel_agency_id not like", value, "travelAgencyId");
            return (Criteria) this;
        }

        public Criteria andTravelAgencyIdIn(List<String> values) {
            addCriterion("travel_agency_id in", values, "travelAgencyId");
            return (Criteria) this;
        }

        public Criteria andTravelAgencyIdNotIn(List<String> values) {
            addCriterion("travel_agency_id not in", values, "travelAgencyId");
            return (Criteria) this;
        }

        public Criteria andTravelAgencyIdBetween(String value1, String value2) {
            addCriterion("travel_agency_id between", value1, value2, "travelAgencyId");
            return (Criteria) this;
        }

        public Criteria andTravelAgencyIdNotBetween(String value1, String value2) {
            addCriterion("travel_agency_id not between", value1, value2, "travelAgencyId");
            return (Criteria) this;
        }

        public Criteria andDistributionPriceIsNull() {
            addCriterion("distribution_price is null");
            return (Criteria) this;
        }

        public Criteria andDistributionPriceIsNotNull() {
            addCriterion("distribution_price is not null");
            return (Criteria) this;
        }

        public Criteria andDistributionPriceEqualTo(BigDecimal value) {
            addCriterion("distribution_price =", value, "distributionPrice");
            return (Criteria) this;
        }

        public Criteria andDistributionPriceNotEqualTo(BigDecimal value) {
            addCriterion("distribution_price <>", value, "distributionPrice");
            return (Criteria) this;
        }

        public Criteria andDistributionPriceGreaterThan(BigDecimal value) {
            addCriterion("distribution_price >", value, "distributionPrice");
            return (Criteria) this;
        }

        public Criteria andDistributionPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("distribution_price >=", value, "distributionPrice");
            return (Criteria) this;
        }

        public Criteria andDistributionPriceLessThan(BigDecimal value) {
            addCriterion("distribution_price <", value, "distributionPrice");
            return (Criteria) this;
        }

        public Criteria andDistributionPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("distribution_price <=", value, "distributionPrice");
            return (Criteria) this;
        }

        public Criteria andDistributionPriceIn(List<BigDecimal> values) {
            addCriterion("distribution_price in", values, "distributionPrice");
            return (Criteria) this;
        }

        public Criteria andDistributionPriceNotIn(List<BigDecimal> values) {
            addCriterion("distribution_price not in", values, "distributionPrice");
            return (Criteria) this;
        }

        public Criteria andDistributionPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("distribution_price between", value1, value2, "distributionPrice");
            return (Criteria) this;
        }

        public Criteria andDistributionPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("distribution_price not between", value1, value2, "distributionPrice");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}